﻿CREATE PROCEDURE [dbo].[marca_selectByDescricao]
	@descricao nvarchar(100)
AS
	SET NOCOUNT ON
	SELECT TBMarca.marcaID, TBMarca.descricao FROM TBMarca WHERE TBMarca.descricao like  '%' + @descricao + '%' ORDER BY TBMarca.descricao